Bill of Material Management Script
What?
A python Script that organizes mechanical drawings, DXFs and STL files on the users operating system into a hierarchical based format that follows a given assembly list. Additionally creates a text file informing the user of missing files from the assembly list. The user will input the assembly list PDF, and the folder name they would like the newly organized files to placed into.
How?
Utilized Regular Expressions and PyPDF libraries to create an algorithm to read through the assembly PDF and user files to pinpoint serial numbers. The program compares the serial numbers
in the assembly list and sifts through the users files to see if there is a match. If there is not a match, it will copy the file name into a missing text file for the user and if there
is a match, it will organize the file into the users folder following the sorting system. The sorting system followings the logic of the assembly list and will read the dashes infront of each
serial number and compare it to the next to see if it is a subpart of the assembly or a new assembly. The logic iterates thorughout the assembly list until all parts of the assembly have been read
and compared to the users files.